{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.read_excel(\"surveydata/pakistan_data.xlsx\", index_col = \"Respondent\")\n",
    "\n",
    "pd.set_option('display.max_columns', 61)\n",
    "pd.set_option('display.max_rows', 61)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>MainBranch</th>\n",
       "      <th>Hobbyist</th>\n",
       "      <th>Age</th>\n",
       "      <th>Age1stCode</th>\n",
       "      <th>CompFreq</th>\n",
       "      <th>CompTotal</th>\n",
       "      <th>ConvertedComp</th>\n",
       "      <th>Country</th>\n",
       "      <th>CurrencyDesc</th>\n",
       "      <th>CurrencySymbol</th>\n",
       "      <th>DatabaseDesireNextYear</th>\n",
       "      <th>DatabaseWorkedWith</th>\n",
       "      <th>DevType</th>\n",
       "      <th>EdLevel</th>\n",
       "      <th>Employment</th>\n",
       "      <th>Ethnicity</th>\n",
       "      <th>Gender</th>\n",
       "      <th>JobFactors</th>\n",
       "      <th>JobSat</th>\n",
       "      <th>JobSeek</th>\n",
       "      <th>LanguageDesireNextYear</th>\n",
       "      <th>LanguageWorkedWith</th>\n",
       "      <th>MiscTechDesireNextYear</th>\n",
       "      <th>MiscTechWorkedWith</th>\n",
       "      <th>NEWCollabToolsDesireNextYear</th>\n",
       "      <th>NEWCollabToolsWorkedWith</th>\n",
       "      <th>NEWDevOps</th>\n",
       "      <th>NEWDevOpsImpt</th>\n",
       "      <th>NEWEdImpt</th>\n",
       "      <th>NEWJobHunt</th>\n",
       "      <th>NEWJobHuntResearch</th>\n",
       "      <th>NEWLearn</th>\n",
       "      <th>NEWOffTopic</th>\n",
       "      <th>NEWOnboardGood</th>\n",
       "      <th>NEWOtherComms</th>\n",
       "      <th>NEWOvertime</th>\n",
       "      <th>NEWPurchaseResearch</th>\n",
       "      <th>NEWPurpleLink</th>\n",
       "      <th>NEWSOSites</th>\n",
       "      <th>NEWStuck</th>\n",
       "      <th>OpSys</th>\n",
       "      <th>OrgSize</th>\n",
       "      <th>PlatformDesireNextYear</th>\n",
       "      <th>PlatformWorkedWith</th>\n",
       "      <th>PurchaseWhat</th>\n",
       "      <th>Sexuality</th>\n",
       "      <th>SOAccount</th>\n",
       "      <th>SOComm</th>\n",
       "      <th>SOPartFreq</th>\n",
       "      <th>SOVisitFreq</th>\n",
       "      <th>SurveyEase</th>\n",
       "      <th>SurveyLength</th>\n",
       "      <th>Trans</th>\n",
       "      <th>UndergradMajor</th>\n",
       "      <th>WebframeDesireNextYear</th>\n",
       "      <th>WebframeWorkedWith</th>\n",
       "      <th>WelcomeChange</th>\n",
       "      <th>WorkWeekHrs</th>\n",
       "      <th>YearsCode</th>\n",
       "      <th>YearsCodePro</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Respondent</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>27.0</td>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>Pakistani rupee</td>\n",
       "      <td>PKR</td>\n",
       "      <td>Couchbase;Elasticsearch;Firebase;MongoDB;MySQL...</td>\n",
       "      <td>Couchbase;MongoDB;PostgreSQL</td>\n",
       "      <td>Developer, back-end;Developer, desktop or ente...</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>South Asian</td>\n",
       "      <td>Man</td>\n",
       "      <td>Flex time or a flexible schedule;How widely us...</td>\n",
       "      <td>Slightly satisfied</td>\n",
       "      <td>I’m not actively looking, but I am open to new...</td>\n",
       "      <td>Dart;Go;HTML/CSS;Java;JavaScript;Python;Rust;T...</td>\n",
       "      <td>Bash/Shell/PowerShell;HTML/CSS;Java;JavaScript...</td>\n",
       "      <td>.NET Core;Flutter;Node.js;Pandas;React Native;...</td>\n",
       "      <td>Cordova;Node.js</td>\n",
       "      <td>Confluence;Jira;Github;Trello;Google Suite (Do...</td>\n",
       "      <td>Confluence;Jira;Github;Gitlab;Trello;Google Su...</td>\n",
       "      <td>No</td>\n",
       "      <td>Extremely important</td>\n",
       "      <td>Very important</td>\n",
       "      <td>Curious about other opportunities;Better compe...</td>\n",
       "      <td>Read company media, such as employee blogs or ...</td>\n",
       "      <td>Every few months</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Occasionally: 1-2 days per quarter but less th...</td>\n",
       "      <td>Start a free trial;Ask developers I know/work ...</td>\n",
       "      <td>Hello, old friend</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who code...</td>\n",
       "      <td>Play games;Call a coworker or friend;Visit Sta...</td>\n",
       "      <td>MacOS</td>\n",
       "      <td>20 to 99 employees</td>\n",
       "      <td>AWS;Docker;Google Cloud Platform;Kubernetes;Li...</td>\n",
       "      <td>Android;Arduino;AWS;Docker;iOS;Linux;MacOS</td>\n",
       "      <td>I have some influence</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, definitely</td>\n",
       "      <td>Daily or almost daily</td>\n",
       "      <td>Multiple times per day</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Angular;Django;Express;React.js;Spring</td>\n",
       "      <td>Angular;Angular.js;Express;jQuery;Spring</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>569</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>No</td>\n",
       "      <td>32.0</td>\n",
       "      <td>22</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>220000.0</td>\n",
       "      <td>17124.0</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>Pakistani rupee</td>\n",
       "      <td>PKR</td>\n",
       "      <td>Firebase;MongoDB;Redis</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Developer, front-end;Developer, full-stack</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>South Asian</td>\n",
       "      <td>Man</td>\n",
       "      <td>Languages, frameworks, and other technologies ...</td>\n",
       "      <td>Slightly dissatisfied</td>\n",
       "      <td>I am actively looking for a job</td>\n",
       "      <td>JavaScript;SQL;TypeScript</td>\n",
       "      <td>HTML/CSS;JavaScript</td>\n",
       "      <td>Node.js</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jira;Github;Slack;Trello;Google Suite (Docs, M...</td>\n",
       "      <td>Jira;Github;Slack;Trello;Google Suite (Docs, M...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Extremely important</td>\n",
       "      <td>Somewhat important</td>\n",
       "      <td>Curious about other opportunities;Better compe...</td>\n",
       "      <td>Read company media, such as employee blogs or ...</td>\n",
       "      <td>Every few months</td>\n",
       "      <td>No</td>\n",
       "      <td>Onboarding? What onboarding?</td>\n",
       "      <td>No</td>\n",
       "      <td>Rarely: 1-2 days per year or less</td>\n",
       "      <td>Ask developers I know/work with;Visit develope...</td>\n",
       "      <td>Annoyed</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who code...</td>\n",
       "      <td>Call a coworker or friend;Visit Stack Overflow...</td>\n",
       "      <td>MacOS</td>\n",
       "      <td>100 to 499 employees</td>\n",
       "      <td>MacOS</td>\n",
       "      <td>MacOS</td>\n",
       "      <td>I have a great deal of influence</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, somewhat</td>\n",
       "      <td>A few times per month or weekly</td>\n",
       "      <td>Daily or almost daily</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Express;jQuery;React.js;Vue.js</td>\n",
       "      <td>jQuery</td>\n",
       "      <td>A lot less welcome now than last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>634</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>25.0</td>\n",
       "      <td>18</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>192.0</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>Pakistani rupee</td>\n",
       "      <td>PKR</td>\n",
       "      <td>Microsoft SQL Server;MySQL;SQLite</td>\n",
       "      <td>Microsoft SQL Server;MySQL;SQLite</td>\n",
       "      <td>Academic researcher;Developer, desktop or ente...</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Independent contractor, freelancer, or self-em...</td>\n",
       "      <td>East Asian</td>\n",
       "      <td>Man</td>\n",
       "      <td>Flex time or a flexible schedule</td>\n",
       "      <td>Neither satisfied nor dissatisfied</td>\n",
       "      <td>I’m not actively looking, but I am open to new...</td>\n",
       "      <td>C#;Java</td>\n",
       "      <td>C#;Java</td>\n",
       "      <td>.NET</td>\n",
       "      <td>.NET</td>\n",
       "      <td>Github</td>\n",
       "      <td>Github</td>\n",
       "      <td>Not sure</td>\n",
       "      <td>Not at all important</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Better compensation;Trouble with my direct man...</td>\n",
       "      <td>Directly asking current or past employees at t...</td>\n",
       "      <td>Once every few years</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Onboarding? What onboarding?</td>\n",
       "      <td>No</td>\n",
       "      <td>Occasionally: 1-2 days per quarter but less th...</td>\n",
       "      <td>Start a free trial</td>\n",
       "      <td>Annoyed</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who codes)</td>\n",
       "      <td>Visit Stack Overflow</td>\n",
       "      <td>Windows</td>\n",
       "      <td>Just me - I am a freelancer, sole proprietor, ...</td>\n",
       "      <td>Windows</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, somewhat</td>\n",
       "      <td>A few times per month or weekly</td>\n",
       "      <td>Multiple times per day</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Too long</td>\n",
       "      <td>No</td>\n",
       "      <td>Information systems, information technology, o...</td>\n",
       "      <td>ASP.NET</td>\n",
       "      <td>ASP.NET</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>42.0</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>763</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Firebase;MySQL;SQLite</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Student</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Man</td>\n",
       "      <td>Languages, frameworks, and other technologies ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>I am actively looking for a job</td>\n",
       "      <td>C</td>\n",
       "      <td>C;HTML/CSS;Java;JavaScript;PHP;Python;SQL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Node.js</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Github</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Just because</td>\n",
       "      <td>Personal network - friends or family</td>\n",
       "      <td>Every few months</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Start a free trial</td>\n",
       "      <td>Hello, old friend</td>\n",
       "      <td>Stack Overflow Jobs (for job seekers)</td>\n",
       "      <td>Watch help / tutorial videos</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Android</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Too short</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Laravel</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>830</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>25.0</td>\n",
       "      <td>22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>Pakistani rupee</td>\n",
       "      <td>PKR</td>\n",
       "      <td>Microsoft SQL Server</td>\n",
       "      <td>Microsoft SQL Server</td>\n",
       "      <td>Data scientist or machine learning specialist</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>South Asian</td>\n",
       "      <td>Man</td>\n",
       "      <td>Industry that I’d be working in;Remote work op...</td>\n",
       "      <td>Neither satisfied nor dissatisfied</td>\n",
       "      <td>I’m not actively looking, but I am open to new...</td>\n",
       "      <td>Python;Scala</td>\n",
       "      <td>Python;R</td>\n",
       "      <td>Apache Spark;Hadoop;Keras;TensorFlow;Torch/PyT...</td>\n",
       "      <td>Keras;TensorFlow</td>\n",
       "      <td>Github</td>\n",
       "      <td>Github</td>\n",
       "      <td>No</td>\n",
       "      <td>Not very important</td>\n",
       "      <td>Somewhat important</td>\n",
       "      <td>Having a bad day (or week or month) at work;Be...</td>\n",
       "      <td>Read company media, such as employee blogs or ...</td>\n",
       "      <td>Every few months</td>\n",
       "      <td>No</td>\n",
       "      <td>Onboarding? What onboarding?</td>\n",
       "      <td>No</td>\n",
       "      <td>Sometimes: 1-2 days per month but less than we...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hello, old friend</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who codes)</td>\n",
       "      <td>Visit Stack Overflow;Watch help / tutorial vid...</td>\n",
       "      <td>MacOS</td>\n",
       "      <td>10,000 or more employees</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>I have little or no influence</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, definitely</td>\n",
       "      <td>Less than once per month or monthly</td>\n",
       "      <td>Multiple times per day</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Mathematics or statistics</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                MainBranch Hobbyist   Age Age1stCode CompFreq  \\\n",
       "Respondent                                                                      \n",
       "201         I am a developer by profession      Yes  27.0         18      NaN   \n",
       "569         I am a developer by profession       No  32.0         22  Monthly   \n",
       "634         I am a developer by profession      Yes  25.0         18  Monthly   \n",
       "763         I am a developer by profession      Yes   NaN         15      NaN   \n",
       "830         I am a developer by profession      Yes  25.0         22      NaN   \n",
       "\n",
       "            CompTotal  ConvertedComp   Country     CurrencyDesc  \\\n",
       "Respondent                                                        \n",
       "201               NaN            NaN  Pakistan  Pakistani rupee   \n",
       "569          220000.0        17124.0  Pakistan  Pakistani rupee   \n",
       "634            2500.0          192.0  Pakistan  Pakistani rupee   \n",
       "763               NaN            NaN  Pakistan              NaN   \n",
       "830               NaN            NaN  Pakistan  Pakistani rupee   \n",
       "\n",
       "           CurrencySymbol                             DatabaseDesireNextYear  \\\n",
       "Respondent                                                                     \n",
       "201                   PKR  Couchbase;Elasticsearch;Firebase;MongoDB;MySQL...   \n",
       "569                   PKR                             Firebase;MongoDB;Redis   \n",
       "634                   PKR                  Microsoft SQL Server;MySQL;SQLite   \n",
       "763                   NaN                                                NaN   \n",
       "830                   PKR                               Microsoft SQL Server   \n",
       "\n",
       "                           DatabaseWorkedWith  \\\n",
       "Respondent                                      \n",
       "201              Couchbase;MongoDB;PostgreSQL   \n",
       "569                                       NaN   \n",
       "634         Microsoft SQL Server;MySQL;SQLite   \n",
       "763                     Firebase;MySQL;SQLite   \n",
       "830                      Microsoft SQL Server   \n",
       "\n",
       "                                                      DevType  \\\n",
       "Respondent                                                      \n",
       "201         Developer, back-end;Developer, desktop or ente...   \n",
       "569                Developer, front-end;Developer, full-stack   \n",
       "634         Academic researcher;Developer, desktop or ente...   \n",
       "763                                                       NaN   \n",
       "830             Data scientist or machine learning specialist   \n",
       "\n",
       "                                                 EdLevel  \\\n",
       "Respondent                                                 \n",
       "201         Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "569         Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "634         Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "763         Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "830         Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "\n",
       "                                                   Employment    Ethnicity  \\\n",
       "Respondent                                                                   \n",
       "201                                        Employed full-time  South Asian   \n",
       "569                                        Employed full-time  South Asian   \n",
       "634         Independent contractor, freelancer, or self-em...   East Asian   \n",
       "763                                                   Student          NaN   \n",
       "830                                        Employed full-time  South Asian   \n",
       "\n",
       "           Gender                                         JobFactors  \\\n",
       "Respondent                                                             \n",
       "201           Man  Flex time or a flexible schedule;How widely us...   \n",
       "569           Man  Languages, frameworks, and other technologies ...   \n",
       "634           Man                   Flex time or a flexible schedule   \n",
       "763           Man  Languages, frameworks, and other technologies ...   \n",
       "830           Man  Industry that I’d be working in;Remote work op...   \n",
       "\n",
       "                                        JobSat  \\\n",
       "Respondent                                       \n",
       "201                         Slightly satisfied   \n",
       "569                      Slightly dissatisfied   \n",
       "634         Neither satisfied nor dissatisfied   \n",
       "763                                        NaN   \n",
       "830         Neither satisfied nor dissatisfied   \n",
       "\n",
       "                                                      JobSeek  \\\n",
       "Respondent                                                      \n",
       "201         I’m not actively looking, but I am open to new...   \n",
       "569                           I am actively looking for a job   \n",
       "634         I’m not actively looking, but I am open to new...   \n",
       "763                           I am actively looking for a job   \n",
       "830         I’m not actively looking, but I am open to new...   \n",
       "\n",
       "                                       LanguageDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "201         Dart;Go;HTML/CSS;Java;JavaScript;Python;Rust;T...   \n",
       "569                                 JavaScript;SQL;TypeScript   \n",
       "634                                                   C#;Java   \n",
       "763                                                         C   \n",
       "830                                              Python;Scala   \n",
       "\n",
       "                                           LanguageWorkedWith  \\\n",
       "Respondent                                                      \n",
       "201         Bash/Shell/PowerShell;HTML/CSS;Java;JavaScript...   \n",
       "569                                       HTML/CSS;JavaScript   \n",
       "634                                                   C#;Java   \n",
       "763                 C;HTML/CSS;Java;JavaScript;PHP;Python;SQL   \n",
       "830                                                  Python;R   \n",
       "\n",
       "                                       MiscTechDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "201         .NET Core;Flutter;Node.js;Pandas;React Native;...   \n",
       "569                                                   Node.js   \n",
       "634                                                      .NET   \n",
       "763                                                       NaN   \n",
       "830         Apache Spark;Hadoop;Keras;TensorFlow;Torch/PyT...   \n",
       "\n",
       "           MiscTechWorkedWith  \\\n",
       "Respondent                      \n",
       "201           Cordova;Node.js   \n",
       "569                       NaN   \n",
       "634                      .NET   \n",
       "763                   Node.js   \n",
       "830          Keras;TensorFlow   \n",
       "\n",
       "                                 NEWCollabToolsDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "201         Confluence;Jira;Github;Trello;Google Suite (Do...   \n",
       "569         Jira;Github;Slack;Trello;Google Suite (Docs, M...   \n",
       "634                                                    Github   \n",
       "763                                                       NaN   \n",
       "830                                                    Github   \n",
       "\n",
       "                                     NEWCollabToolsWorkedWith NEWDevOps  \\\n",
       "Respondent                                                                \n",
       "201         Confluence;Jira;Github;Gitlab;Trello;Google Su...        No   \n",
       "569         Jira;Github;Slack;Trello;Google Suite (Docs, M...       Yes   \n",
       "634                                                    Github  Not sure   \n",
       "763                                                    Github       NaN   \n",
       "830                                                    Github        No   \n",
       "\n",
       "                   NEWDevOpsImpt           NEWEdImpt  \\\n",
       "Respondent                                             \n",
       "201          Extremely important      Very important   \n",
       "569          Extremely important  Somewhat important   \n",
       "634         Not at all important                 NaN   \n",
       "763                          NaN                 NaN   \n",
       "830           Not very important  Somewhat important   \n",
       "\n",
       "                                                   NEWJobHunt  \\\n",
       "Respondent                                                      \n",
       "201         Curious about other opportunities;Better compe...   \n",
       "569         Curious about other opportunities;Better compe...   \n",
       "634         Better compensation;Trouble with my direct man...   \n",
       "763                                              Just because   \n",
       "830         Having a bad day (or week or month) at work;Be...   \n",
       "\n",
       "                                           NEWJobHuntResearch  \\\n",
       "Respondent                                                      \n",
       "201         Read company media, such as employee blogs or ...   \n",
       "569         Read company media, such as employee blogs or ...   \n",
       "634         Directly asking current or past employees at t...   \n",
       "763                      Personal network - friends or family   \n",
       "830         Read company media, such as employee blogs or ...   \n",
       "\n",
       "                        NEWLearn NEWOffTopic                NEWOnboardGood  \\\n",
       "Respondent                                                                   \n",
       "201             Every few months          No                           Yes   \n",
       "569             Every few months          No  Onboarding? What onboarding?   \n",
       "634         Once every few years         Yes  Onboarding? What onboarding?   \n",
       "763             Every few months         NaN                           NaN   \n",
       "830             Every few months          No  Onboarding? What onboarding?   \n",
       "\n",
       "           NEWOtherComms                                        NEWOvertime  \\\n",
       "Respondent                                                                    \n",
       "201                  Yes  Occasionally: 1-2 days per quarter but less th...   \n",
       "569                   No                  Rarely: 1-2 days per year or less   \n",
       "634                   No  Occasionally: 1-2 days per quarter but less th...   \n",
       "763                   No                                                NaN   \n",
       "830                   No  Sometimes: 1-2 days per month but less than we...   \n",
       "\n",
       "                                          NEWPurchaseResearch  \\\n",
       "Respondent                                                      \n",
       "201         Start a free trial;Ask developers I know/work ...   \n",
       "569         Ask developers I know/work with;Visit develope...   \n",
       "634                                        Start a free trial   \n",
       "763                                        Start a free trial   \n",
       "830                                                       NaN   \n",
       "\n",
       "                NEWPurpleLink  \\\n",
       "Respondent                      \n",
       "201         Hello, old friend   \n",
       "569                   Annoyed   \n",
       "634                   Annoyed   \n",
       "763         Hello, old friend   \n",
       "830         Hello, old friend   \n",
       "\n",
       "                                                   NEWSOSites  \\\n",
       "Respondent                                                      \n",
       "201         Stack Overflow (public Q&A for anyone who code...   \n",
       "569         Stack Overflow (public Q&A for anyone who code...   \n",
       "634          Stack Overflow (public Q&A for anyone who codes)   \n",
       "763                     Stack Overflow Jobs (for job seekers)   \n",
       "830          Stack Overflow (public Q&A for anyone who codes)   \n",
       "\n",
       "                                                     NEWStuck    OpSys  \\\n",
       "Respondent                                                               \n",
       "201         Play games;Call a coworker or friend;Visit Sta...    MacOS   \n",
       "569         Call a coworker or friend;Visit Stack Overflow...    MacOS   \n",
       "634                                      Visit Stack Overflow  Windows   \n",
       "763                              Watch help / tutorial videos  Windows   \n",
       "830         Visit Stack Overflow;Watch help / tutorial vid...    MacOS   \n",
       "\n",
       "                                                      OrgSize  \\\n",
       "Respondent                                                      \n",
       "201                                        20 to 99 employees   \n",
       "569                                      100 to 499 employees   \n",
       "634         Just me - I am a freelancer, sole proprietor, ...   \n",
       "763                                                       NaN   \n",
       "830                                  10,000 or more employees   \n",
       "\n",
       "                                       PlatformDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "201         AWS;Docker;Google Cloud Platform;Kubernetes;Li...   \n",
       "569                                                     MacOS   \n",
       "634                                                   Windows   \n",
       "763                                                       NaN   \n",
       "830                                                       NaN   \n",
       "\n",
       "                                    PlatformWorkedWith  \\\n",
       "Respondent                                               \n",
       "201         Android;Arduino;AWS;Docker;iOS;Linux;MacOS   \n",
       "569                                              MacOS   \n",
       "634                                            Windows   \n",
       "763                                            Android   \n",
       "830                                                NaN   \n",
       "\n",
       "                                PurchaseWhat                Sexuality  \\\n",
       "Respondent                                                              \n",
       "201                    I have some influence  Straight / Heterosexual   \n",
       "569         I have a great deal of influence  Straight / Heterosexual   \n",
       "634                                      NaN  Straight / Heterosexual   \n",
       "763                                      NaN                      NaN   \n",
       "830            I have little or no influence  Straight / Heterosexual   \n",
       "\n",
       "           SOAccount           SOComm                           SOPartFreq  \\\n",
       "Respondent                                                                   \n",
       "201              Yes  Yes, definitely                Daily or almost daily   \n",
       "569              Yes    Yes, somewhat      A few times per month or weekly   \n",
       "634              Yes    Yes, somewhat      A few times per month or weekly   \n",
       "763              NaN              NaN                                  NaN   \n",
       "830              Yes  Yes, definitely  Less than once per month or monthly   \n",
       "\n",
       "                       SOVisitFreq                  SurveyEase  \\\n",
       "Respondent                                                       \n",
       "201         Multiple times per day                        Easy   \n",
       "569          Daily or almost daily  Neither easy nor difficult   \n",
       "634         Multiple times per day                        Easy   \n",
       "763                            NaN                        Easy   \n",
       "830         Multiple times per day  Neither easy nor difficult   \n",
       "\n",
       "                     SurveyLength Trans  \\\n",
       "Respondent                                \n",
       "201         Appropriate in length    No   \n",
       "569         Appropriate in length    No   \n",
       "634                      Too long    No   \n",
       "763                     Too short    No   \n",
       "830         Appropriate in length    No   \n",
       "\n",
       "                                               UndergradMajor  \\\n",
       "Respondent                                                      \n",
       "201         Computer science, computer engineering, or sof...   \n",
       "569         Computer science, computer engineering, or sof...   \n",
       "634         Information systems, information technology, o...   \n",
       "763         Computer science, computer engineering, or sof...   \n",
       "830                                 Mathematics or statistics   \n",
       "\n",
       "                            WebframeDesireNextYear  \\\n",
       "Respondent                                           \n",
       "201         Angular;Django;Express;React.js;Spring   \n",
       "569                 Express;jQuery;React.js;Vue.js   \n",
       "634                                        ASP.NET   \n",
       "763                                            NaN   \n",
       "830                                            NaN   \n",
       "\n",
       "                                  WebframeWorkedWith  \\\n",
       "Respondent                                             \n",
       "201         Angular;Angular.js;Express;jQuery;Spring   \n",
       "569                                           jQuery   \n",
       "634                                          ASP.NET   \n",
       "763                                          Laravel   \n",
       "830                                              NaN   \n",
       "\n",
       "                                      WelcomeChange  WorkWeekHrs YearsCode  \\\n",
       "Respondent                                                                   \n",
       "201         Just as welcome now as I felt last year         40.0         9   \n",
       "569           A lot less welcome now than last year         40.0         8   \n",
       "634         Just as welcome now as I felt last year         42.0         6   \n",
       "763                                             NaN          NaN        14   \n",
       "830         Just as welcome now as I felt last year         40.0         4   \n",
       "\n",
       "           YearsCodePro  \n",
       "Respondent               \n",
       "201                   4  \n",
       "569                   6  \n",
       "634                   3  \n",
       "763                 NaN  \n",
       "830                   2  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3rc1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
